﻿CREATE TABLE [dbo].[ProductieOperatiuni] (
    [IDOperatiune]   INT           IDENTITY (1, 1) NOT NULL,
    [Denumire]       VARCHAR (50)  NOT NULL,
    [Descriere]      VARCHAR (250) NOT NULL,
    [Utilaj]         VARCHAR (100) NOT NULL,
    [NrPersoane]     SMALLINT      DEFAULT ((0)) NOT NULL,
    [Randament]      FLOAT (53)    DEFAULT ((0)) NOT NULL,
    [Pozitie]        SMALLINT      DEFAULT ((0)) NOT NULL,
    [IDArticolFinit] INT           NOT NULL,
    [Activ]          BIT           DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_ProductieOperatiuni] PRIMARY KEY CLUSTERED ([IDOperatiune] ASC),
    CONSTRAINT [FK_ProductieOperatiuni_Articole] FOREIGN KEY ([IDArticolFinit]) REFERENCES [dbo].[Articole] ([IDArticol])
);

